Does anyone know what the syntax for the "In" operator is when setting a filter on a matrix.

Any clue on this. I have tried (value,value), value;value, value,value. and multiple other combinations. I have been unsuccessful on finding anthing about this.

Perhaps quotes would work? Also try View Code and edit the XML manually (backup the report first.) The syntax to look for is this: <Filter> ... <FilterValues> <FilterValue>...</FilterValue> </FilterValues> ...</Filter> Once you change the XML, go back into your filter to see what the resulting syntax is.

No dice. Still not able to use 'IN' operator for table filter.

If you want to use the IN filter, the filter value expression has to return a multi-dimensional array. Typically you would use an IN filter with a multi-select report parameter.If you want to define your own list of values, you can use an expression like this:=Split("value1,value2,value3", ",")The Split function will create a multidimensional string array out of the original string.-- Robert

If you want to use the IN filter, the filter value expression has to return a multi-dimensional array. Typically you would use an IN filter with a multi-select report parameter. If you want to define your own list of values, you can use an expression like this: =Split("value1,value2,value3", ",") The Split function will create a multidimensional string array out of the original string. -- Robert THANK YOU THANK YOU for that, I have spent a LONG time on google this to find the answer. Dawned on me to try the user forums specifically for Microsoft. It would have been nice for MS to put an example into the help files.